Dataset info
| Number of variables | 90 |
|---|---|
| Number of observations | 2968 |
| Missing cells | 87159 (32.6%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 1.1 MiB |
| Average record size in memory | 400.0 B |
Variables types
| Numeric | 4 |
|---|---|
| Categorical | 67 |
| Boolean | 0 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 4 |
| Rejected | 15 |
| Unsupported | 0 |
Warnings
ADDITIVES_BRANDED_DIESEL_IND has constant value "Y" | Rejected |
ADDITIVES_BRANDED_GASOLINE_IND has constant value "Y" | Rejected |
ADDITIVES_DYE_IND has constant value "Y" | Rejected |
ADDITIVES_LUBRICITY_IND has constant value "Y" | Rejected |
ADDITIVES_UNBRANDED_GASOLINE_IND has constant value "Y" | Rejected |
CF3030_LINE_CODE has 106 (< 0.1%) missing values | Missing |
CF3030_LINE_DESC has 105 (< 0.1%) missing values | Missing |
CF3030_LINE_LVL1_DESC has 105 (< 0.1%) missing values | Missing |
CF3030_LINE_LVL2_DESC has 105 (< 0.1%) missing values | Missing |
CONTAINER_REQUIREMENTS has a high cardinality: 112 distinct values | Warning |
CONTAINER_REQUIREMENTS has 2554 (86.1%) missing values | Missing |
EMAPSS_MATERIAL has a high cardinality: 847 distinct values | Warning |
EMAPSS_MATERIAL has 2122 (71.5%) missing values | Missing |
GOM_MATERIAL is highly skewed (γ1 = -24.454) | Skewed |
GOM_MATERIAL has 2370 (79.9%) missing values | Missing |
GPAQS_CMCS_CODE has a high cardinality: 680 distinct values | Warning |
GPAQS_CMCS_CODE has 2033 (68.5%) missing values | Missing |
GPAQS_MATERIAL_NAME has a high cardinality: 656 distinct values | Warning |
GPAQS_MATERIAL_NAME has 2036 (68.6%) missing values | Missing |
LS_GLOBAL_BRAND has constant value "XOM" | Rejected |
LS_GLOBAL_BRAND_DESC has constant value "ExxonMobil" | Rejected |
LS_GLOBAL_BULK_PACK_ID has 159 (5.4%) missing values | Missing |
LS_GLOBAL_PACKAGE_GROUP has 158 (5.3%) missing values | Missing |
LS_GLOBAL_PREMIUM_IND has 1997 (67.3%) missing values | Missing |
LS_GLOBAL_PREMIUM_IND_DESC has constant value "None" | Rejected |
LS_GLOBAL_PROD_FAMILY has 1997 (67.3%) missing values | Missing |
LS_GLOBAL_PROD_FAMILY_DESC has 1997 (67.3%) missing values | Missing |
LS_GLOBAL_PRODUCT_GROUP has 1997 (67.3%) missing values | Missing |
LS_GLOBAL_PRODUCT_GROUP_DESC has 1997 (67.3%) missing values | Missing |
LS_GLOBAL_PRODUCT_LINE has 1996 (67.3%) missing values | Missing |
LS_GLOBAL_PRODUCT_LINE_DESC has 1997 (67.3%) missing values | Missing |
LS_GLOBAL_PRODUCT_NUMBER has 1996 (67.3%) missing values | Missing |
LS_GLOBAL_SYNTHETIC_IND has constant value "MIN" | Rejected |
LS_GLOBAL_SYNTHETIC_IND_DESC has constant value "Mineral" | Rejected |
MATERIAL_DEL_IND has 2639 (88.9%) missing values | Missing |
MATERIAL_DESC has a high cardinality: 2916 distinct values | Warning |
MATERIAL_DESC has 39 (< 0.1%) missing values | Missing |
MATERIAL_DIVISION has 33 (< 0.1%) missing values | Missing |
MATERIAL_GROSS_WEIGHT has a high cardinality: 344 distinct values | Warning |
MATERIAL_GROUP has 36 (< 0.1%) missing values | Missing |
MATERIAL_GROUP_DESC has 99 (< 0.1%) missing values | Missing |
MATERIAL_NET_WEIGHT has a high cardinality: 247 distinct values | Warning |
MATERIAL_PROD_FAMILY_BLENDED has 1461 (49.2%) missing values | Missing |
MATERIAL_PROD_FAMILY_BLENDED_DESC has 1464 (49.3%) missing values | Missing |
MATERIAL_PROD_FAMILY_BLENDED_GROUP has 1464 (49.3%) missing values | Missing |
MATERIAL_PROD_FAMILY_UNBLENDED has 1462 (49.3%) missing values | Missing |
MATERIAL_PROD_FAMILY_UNBLENDED_DESC has 1464 (49.3%) missing values | Missing |
MATERIAL_PROD_FAMILY_UNBLENDED_GROUP has 1464 (49.3%) missing values | Missing |
MATERIAL_SOURCE_SYSTEM has constant value "nan" | Rejected |
MATERIAL_STCC has 2407 (81.1%) missing values | Missing |
MATERIAL_STCC_DESC has 2407 (81.1%) missing values | Missing |
MATERIAL_TYPE has 32 (< 0.1%) missing values | Missing |
MATERIAL_TYPE_DESC has 32 (< 0.1%) missing values | Missing |
MATERIAL_UOM has 32 (< 0.1%) missing values | Missing |
MATERIAL_VOL has a high cardinality: 352 distinct values | Warning |
PROD_HIER has a high cardinality: 55 distinct values | Warning |
PROD_HIER has 71 (< 0.1%) missing values | Missing |
PROD_LVL1 has 71 (< 0.1%) missing values | Missing |
PROD_LVL1_NO has 71 (< 0.1%) missing values | Missing |
PROD_LVL2 has 105 (< 0.1%) missing values | Missing |
PROD_LVL2_NO is highly correlated with PROD_LVL1_NO (ρ = 0.99999) | Rejected |
PROD_LVL3 has 105 (< 0.1%) missing values | Missing |
PROD_LVL3_NO has 105 (< 0.1%) missing values | Missing |
PROD_LVL4 has 118 (< 0.1%) missing values | Missing |
PROD_LVL4_NO has 118 (< 0.1%) missing values | Missing |
PROD_LVL5 has 1826 (61.5%) missing values | Missing |
PROD_LVL5_NO has 1825 (61.5%) missing values | Missing |
PROD_LVL6 has 2966 (> 99.9%) missing values | Missing |
PROD_LVL6_NO has constant value "nan" | Rejected |
SHIPNET_COMMODITY has constant value "nan" | Rejected |
TRANSPORT_GROUP has 113 (< 0.1%) missing values | Missing |
VOL_UOM_CODE has 112 (< 0.1%) missing values | Missing |
VR_CLASS_LVL1 has 194 (6.5%) missing values | Missing |
VR_CLASS_LVL1_NO has constant value "VR9999" | Rejected |
VR_CLASS_LVL2 has 194 (6.5%) missing values | Missing |
VR_CLASS_LVL2_NO has 194 (6.5%) missing values | Missing |
VR_CLASS_LVL3 has 194 (6.5%) missing values | Missing |
VR_CLASS_LVL3_NO has 194 (6.5%) missing values | Missing |
VR_CLASS_LVL4 has a high cardinality: 101 distinct values | Warning |
VR_CLASS_LVL4 has 194 (6.5%) missing values | Missing |
VR_CLASS_LVL4_NO has a high cardinality: 102 distinct values | Warning |
VR_CLASS_LVL4_NO has 194 (6.5%) missing values | Missing |
WEIGHT_UOM_CODE has 32 (< 0.1%) missing values | Missing |
ADDITIVES_BRANDED_DIESEL_IND
Constant
This variable is constant and should be ignored for analysis
| Constant value | Y |
|---|
ADDITIVES_BRANDED_GASOLINE_IND
Constant
This variable is constant and should be ignored for analysis
| Constant value | Y |
|---|
ADDITIVES_DYE_IND
Constant
This variable is constant and should be ignored for analysis
| Constant value | Y |
|---|
ADDITIVES_LUBRICITY_IND
Constant
This variable is constant and should be ignored for analysis
| Constant value | Y |
|---|
ADDITIVES_UNBRANDED_GASOLINE_IND
Constant
This variable is constant and should be ignored for analysis
| Constant value | Y |
|---|
CF3030_LINE_CODE
Numeric
| Distinct count | 11 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 106 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 192.67 |
|---|---|
| Minimum | 10 |
| Maximum | 9999 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 40 |
| Q1 | 40 |
| Median | 85 |
| Q3 | 260 |
| 95-th percentile | 270 |
| Maximum | 9999 |
| Range | 9989 |
| Interquartile range | 220 |
Descriptive statistics
| Standard deviation | 579.36 |
|---|---|
| Coef of variation | 3.007 |
| Kurtosis | 255.86 |
| Mean | 192.67 |
| MAD | 159.25 |
| Skewness | 15.345 |
| Sum | 5.5142e+05 |
| Variance | 3.3566e+05 |
| Memory size | 23.2 KiB |
| Value | Count | Frequency (%) | |
| 260 | 912 | 30.7% | |
| 40 | 848 | 28.6% | |
| 85 | 812 | 27.4% | |
| 999 | 92 | < 0.1% | |
| 270 | 52 | < 0.1% | |
| 125 | 49 | < 0.1% | |
| 160 | 45 | < 0.1% | |
| 10 | 34 | < 0.1% | |
| 195 | 9 | < 0.1% | |
| 9999 | 9 | < 0.1% | |
| (Missing) | 106 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 10 | 34 | < 0.1% | |
| 40 | 848 | 28.6% | |
| 85 | 812 | 27.4% | |
| 125 | 49 | < 0.1% | |
| 160 | 45 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 9999 | 9 | < 0.1% | |
| 999 | 92 | < 0.1% | |
| 270 | 52 | < 0.1% | |
| 260 | 912 | 30.7% | |
| 195 | 9 | < 0.1% |
CF3030_LINE_DESC
Categorical
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 105 |
| Finished Lubes | |
|---|---|
| Motor Gasoline | |
| Distillate Fuels | |
| Other values (8) | |
| (Missing) | 105 |
| Value | Count | Frequency (%) | |
| Finished Lubes | 912 | 30.7% | |
| Motor Gasoline | 848 | 28.6% | |
| Distillate Fuels | 812 | 27.4% | |
| Unassigned Classes | 92 | < 0.1% | |
| Lubes - Basestocks | 52 | < 0.1% | |
| Fuel Oil | 49 | < 0.1% | |
| Liquified Pet Gas | 45 | < 0.1% | |
| Aviation Fuels | 34 | < 0.1% | |
| Undefined | 9 | < 0.1% | |
| Ref Gas & Other Pet | 9 | < 0.1% | |
| (Missing) | 105 | < 0.1% |
| Max length | 19 |
|---|---|
| Mean length | 14.295 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
CF3030_LINE_LVL1_DESC
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 105 |
| Products | |
|---|---|
| Unassigned Classes | 92 |
| Undefined | 9 |
| (Missing) | 105 |
| Value | Count | Frequency (%) | |
| Products | 2761 | 93.0% | |
| Unassigned Classes | 92 | < 0.1% | |
| Undefined | 9 | < 0.1% | |
| Crude | 1 | < 0.1% | |
| (Missing) | 105 | < 0.1% |
| Max length | 18 |
|---|---|
| Mean length | 8.1351 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
CF3030_LINE_LVL2_DESC
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 105 |
| Fuels | |
|---|---|
| Lubes | |
| Unassigned Classes | 92 |
| Other values (2) | 10 |
| (Missing) | 105 |
| Value | Count | Frequency (%) | |
| Fuels | 1797 | 60.5% | |
| Lubes | 964 | 32.5% | |
| Unassigned Classes | 92 | < 0.1% | |
| Undefined | 9 | < 0.1% | |
| Crude | 1 | < 0.1% | |
| (Missing) | 105 | < 0.1% |
| Max length | 18 |
|---|---|
| Mean length | 5.3443 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
CONTAINER_REQUIREMENTS
Categorical
| Distinct count | 112 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 86.1% |
| Missing (n) | 2554 |
| 9B | 77 |
|---|---|
| 7B | 49 |
| 4B | 34 |
| Other values (108) | 254 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 9B | 77 | < 0.1% | |
| 7B | 49 | < 0.1% | |
| 4B | 34 | < 0.1% | |
| 7L | 20 | < 0.1% | |
| 1N | 13 | < 0.1% | |
| 5P | 10 | < 0.1% | |
| 1B | 9 | < 0.1% | |
| 4N | 8 | < 0.1% | |
| 6T | 8 | < 0.1% | |
| 4M | 7 | < 0.1% | |
| Other values (101) | 179 | 6.0% | |
| (Missing) | 2554 | 86.1% |
| Max length | 3 |
|---|---|
| Mean length | 2.8605 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
DH_SRC
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| STRIPES_AM | |
|---|---|
| DSDW_W7 | 39 |
| Value | Count | Frequency (%) | |
| STRIPES_AM | 2929 | > 99.9% | |
| DSDW_W7 | 39 | < 0.1% |
| Max length | 10 |
|---|---|
| Mean length | 9.9606 |
| Min length | 7 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
EMAPSS_MATERIAL
Categorical
| Distinct count | 847 |
|---|---|
| Unique (%) | 28.5% |
| Missing (%) | 71.5% |
| Missing (n) | 2122 |
| 125105 | 1 |
|---|---|
| 110528 | 1 |
| 121902 | 1 |
| Other values (843) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| 125105 | 1 | < 0.1% | |
| 110528 | 1 | < 0.1% | |
| 121902 | 1 | < 0.1% | |
| 100795 | 1 | < 0.1% | |
| 102342 | 1 | < 0.1% | |
| 120524 | 1 | < 0.1% | |
| 103683 | 1 | < 0.1% | |
| 121275 | 1 | < 0.1% | |
| 123508 | 1 | < 0.1% | |
| 103659 | 1 | < 0.1% | |
| Other values (836) | 836 | 28.2% | |
| (Missing) | 2122 | 71.5% |
| Max length | 6 |
|---|---|
| Mean length | 3.8544 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
FUELS_BASE_IND
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Base | |
|---|---|
| Premium | 408 |
| Crude | 1 |
| Value | Count | Frequency (%) | |
| Base | 2559 | 86.2% | |
| Premium | 408 | 13.7% | |
| Crude | 1 | < 0.1% |
| Max length | 7 |
|---|---|
| Mean length | 4.4127 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
GLOB_PROD_LVL1
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Fuels Finished Petroleum Product | |
|---|---|
| Refy Oth External Input | |
| Refinery Processed Input | 79 |
| Value | Count | Frequency (%) | |
| Fuels Finished Petroleum Product | 1743 | 58.7% | |
| Refy Oth External Input | 1141 | 38.4% | |
| Refinery Processed Input | 79 | < 0.1% | |
| Byproducts | 5 | < 0.1% |
| Max length | 32 |
|---|---|
| Mean length | 28.29 |
| Min length | 10 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
GLOB_PROD_LVL1_NO
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 30 | |
|---|---|
| 20 | |
| 10 | 79 |
| Value | Count | Frequency (%) | |
| 30 | 1743 | 58.7% | |
| 20 | 1141 | 38.4% | |
| 10 | 79 | < 0.1% | |
| 50 | 5 | < 0.1% |
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
GLOB_PROD_LVL2
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Clean Products | |
|---|---|
| Non-Proc Refy Inputs | |
| Post-PS Feedstocks | 79 |
| Other values (2) | 64 |
| Value | Count | Frequency (%) | |
| Clean Products | 1684 | 56.7% | |
| Non-Proc Refy Inputs | 1141 | 38.4% | |
| Post-PS Feedstocks | 79 | < 0.1% | |
| Fuel Oils | 59 | < 0.1% | |
| Solids | 5 | < 0.1% |
| Max length | 20 |
|---|---|
| Mean length | 16.3 |
| Min length | 6 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
GLOB_PROD_LVL2_NO
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 20 | |
|---|---|
| 18 | |
| 16 | 79 |
| Other values (2) | 64 |
| Value | Count | Frequency (%) | |
| 20 | 1684 | 56.7% | |
| 18 | 1141 | 38.4% | |
| 16 | 79 | < 0.1% | |
| 31 | 59 | < 0.1% | |
| A7 | 5 | < 0.1% |
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
GLOB_PROD_LVL3
Categorical
| Distinct count | 11 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Additives | |
|---|---|
| Motor Gasoline | |
| Land Diesel | |
| Other values (8) |
| Value | Count | Frequency (%) | |
| Additives | 1141 | 38.4% | |
| Motor Gasoline | 822 | 27.7% | |
| Land Diesel | 711 | 24.0% | |
| Processed Chem Rtns | 79 | < 0.1% | |
| Heating Oil | 68 | < 0.1% | |
| Fuel Oil - Marine | 59 | < 0.1% | |
| Marine Distillates | 28 | < 0.1% | |
| Jet | 26 | < 0.1% | |
| Other Petroleum | 19 | < 0.1% | |
| Kerosene | 10 | < 0.1% |
| Max length | 19 |
|---|---|
| Mean length | 11.417 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
GLOB_PROD_LVL3_NO
Categorical
| Distinct count | 11 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 38 | |
|---|---|
| 50 | |
| 51 | |
| Other values (8) |
| Value | Count | Frequency (%) | |
| 38 | 1141 | 38.4% | |
| 50 | 822 | 27.7% | |
| 51 | 711 | 24.0% | |
| 30 | 79 | < 0.1% | |
| 54 | 68 | < 0.1% | |
| 61 | 59 | < 0.1% | |
| 55 | 28 | < 0.1% | |
| 53 | 26 | < 0.1% | |
| 56 | 19 | < 0.1% | |
| 58 | 10 | < 0.1% |
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
GLOB_PROD_LVL4
Categorical
| Distinct count | 31 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Fuels Additives | |
|---|---|
| Regular ADO | |
| Regular | |
| Other values (28) |
| Value | Count | Frequency (%) | |
| Fuels Additives | 1108 | 37.3% | |
| Regular ADO | 559 | 18.8% | |
| Regular | 306 | 10.3% | |
| Premium | 256 | 8.6% | |
| Intermediate | 140 | < 0.1% | |
| Premium ADO | 129 | < 0.1% | |
| Mogas Discounts Rebates Cards Oth | 118 | < 0.1% | |
| Oth Proc Non-SC Rtns | 52 | < 0.1% | |
| Regular Sulphur Fuel Oil - Marine | 40 | < 0.1% | |
| Regular Heating Oil | 37 | < 0.1% | |
| Other values (21) | 223 | 7.5% |
| Max length | 34 |
|---|---|
| Mean length | 13.78 |
| Min length | 6 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
GLOB_PROD_LVL4_NO
Categorical
| Distinct count | 31 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 381 | |
|---|---|
| 512 | |
| 503 | |
| Other values (28) |
| Value | Count | Frequency (%) | |
| 381 | 1108 | 37.3% | |
| 512 | 559 | 18.8% | |
| 503 | 306 | 10.3% | |
| 501 | 256 | 8.6% | |
| 502 | 140 | < 0.1% | |
| 511 | 129 | < 0.1% | |
| 506 | 118 | < 0.1% | |
| 305 | 52 | < 0.1% | |
| 611 | 40 | < 0.1% | |
| 541 | 37 | < 0.1% | |
| Other values (21) | 223 | 7.5% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
GOM_MATERIAL
Numeric
| Distinct count | 458 |
|---|---|
| Unique (%) | 15.4% |
| Missing (%) | 79.9% |
| Missing (n) | 2370 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 8.9872e+07 |
|---|---|
| Minimum | 7 |
| Maximum | 9.004e+07 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 7 |
|---|---|
| 5-th percentile | 9.0007e+07 |
| Q1 | 9.0011e+07 |
| Median | 9.0025e+07 |
| Q3 | 9.0039e+07 |
| 95-th percentile | 9.004e+07 |
| Maximum | 9.004e+07 |
| Range | 9.004e+07 |
| Interquartile range | 28029 |
Descriptive statistics
| Standard deviation | 3.6813e+06 |
|---|---|
| Coef of variation | 0.040962 |
| Kurtosis | 597.99 |
| Mean | 8.9872e+07 |
| MAD | 3.0058e+05 |
| Skewness | -24.454 |
| Sum | 5.3744e+10 |
| Variance | 1.3552e+13 |
| Memory size | 23.2 KiB |
| Value | Count | Frequency (%) | |
| 9.0027e+07 | 9 | < 0.1% | |
| 9.0014e+07 | 8 | < 0.1% | |
| 9.0025e+07 | 8 | < 0.1% | |
| 9.0025e+07 | 8 | < 0.1% | |
| 9.0027e+07 | 7 | < 0.1% | |
| 9.0014e+07 | 7 | < 0.1% | |
| 9.0007e+07 | 6 | < 0.1% | |
| 9.0007e+07 | 5 | < 0.1% | |
| 9.0011e+07 | 4 | < 0.1% | |
| 9.0007e+07 | 4 | < 0.1% | |
| Other values (447) | 532 | 17.9% | |
| (Missing) | 2370 | 79.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 7 | 1 | < 0.1% | |
| 9.0003e+07 | 1 | < 0.1% | |
| 9.0003e+07 | 1 | < 0.1% | |
| 9.0003e+07 | 1 | < 0.1% | |
| 9.0003e+07 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 9.004e+07 | 1 | < 0.1% | |
| 9.004e+07 | 1 | < 0.1% | |
| 9.004e+07 | 1 | < 0.1% | |
| 9.004e+07 | 1 | < 0.1% | |
| 9.004e+07 | 1 | < 0.1% |
GPAQS_CMCS_CODE
Categorical
| Distinct count | 680 |
|---|---|
| Unique (%) | 22.9% |
| Missing (%) | 68.5% |
| Missing (n) | 2033 |
| 97BD53 | 6 |
|---|---|
| 97AF78 | 6 |
| 97F356 | 6 |
| Other values (676) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| 97BD53 | 6 | < 0.1% | |
| 97AF78 | 6 | < 0.1% | |
| 97F356 | 6 | < 0.1% | |
| 97CH73 | 5 | < 0.1% | |
| 97F179 | 5 | < 0.1% | |
| 97AS51 | 4 | < 0.1% | |
| 97F587 | 4 | < 0.1% | |
| 97V336 | 4 | < 0.1% | |
| 97BB16 | 4 | < 0.1% | |
| 97P468 | 4 | < 0.1% | |
| Other values (669) | 887 | 29.9% | |
| (Missing) | 2033 | 68.5% |
| Max length | 9 |
|---|---|
| Mean length | 3.9586 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
GPAQS_MATERIAL_NAME
Categorical
| Distinct count | 656 |
|---|---|
| Unique (%) | 22.1% |
| Missing (%) | 68.6% |
| Missing (n) | 2036 |
| RED DYE LIQUID | 6 |
|---|---|
| OLOA 249SX | 6 |
| AUTOMATE RED 9BHF | 6 |
| Other values (652) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| RED DYE LIQUID | 6 | < 0.1% | |
| OLOA 249SX | 6 | < 0.1% | |
| AUTOMATE RED 9BHF | 6 | < 0.1% | |
| OLOA 275JR | 5 | < 0.1% | |
| ADEKA SAKURALUBE 515 | 5 | < 0.1% | |
| OLOA 219M | 5 | < 0.1% | |
| INFINEUM SV150 (FORMERLY SAP 150/SHELLVIS 50) | 5 | < 0.1% | |
| DITERTIARY-BUTYL-PARACRESOL | 4 | < 0.1% | |
| INFINEUM V387 (FORMERLY PARAFLOW 387) | 4 | < 0.1% | |
| LUBRIZOL 5515A | 4 | < 0.1% | |
| Other values (645) | 882 | 29.7% | |
| (Missing) | 2036 | 68.6% |
| Max length | 61 |
|---|---|
| Mean length | 7.4555 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
LS_GLOBAL_BRAND
Constant
This variable is constant and should be ignored for analysis
| Constant value | XOM |
|---|
LS_GLOBAL_BRAND_DESC
Constant
This variable is constant and should be ignored for analysis
| Constant value | ExxonMobil |
|---|
LS_GLOBAL_BULK_PACK_ID
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 5.4% |
| Missing (n) | 159 |
| BULK | |
|---|---|
| PACK | |
| (Missing) | 159 |
| Value | Count | Frequency (%) | |
| BULK | 2176 | 73.3% | |
| PACK | 633 | 21.3% | |
| (Missing) | 159 | 5.4% |
| Max length | 4 |
|---|---|
| Mean length | 3.9464 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
LS_GLOBAL_PACKAGE_GROUP
Categorical
| Distinct count | 11 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 5.3% |
| Missing (n) | 158 |
| BULK | |
|---|---|
| DRUM | |
| OTH | 81 |
| Other values (7) | 69 |
| (Missing) | 158 |
| Value | Count | Frequency (%) | |
| BULK | 2174 | 73.2% | |
| DRUM | 486 | 16.4% | |
| OTH | 81 | < 0.1% | |
| KEG | 28 | < 0.1% | |
| PAIL | 25 | < 0.1% | |
| BOLG | 5 | < 0.1% | |
| TOTE | 4 | < 0.1% | |
| BOSM | 3 | < 0.1% | |
| IBC | 3 | < 0.1% | |
| BIN | 1 | < 0.1% | |
| (Missing) | 158 | 5.3% |
| Max length | 4 |
|---|---|
| Mean length | 3.9087 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
LS_GLOBAL_PREMIUM_IND
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 67.3% |
| Missing (n) | 1997 |
| NON | |
|---|---|
| OTHER | 13 |
| (Missing) |
| Value | Count | Frequency (%) | |
| NON | 958 | 32.3% | |
| OTHER | 13 | < 0.1% | |
| (Missing) | 1997 | 67.3% |
| Max length | 5 |
|---|---|
| Mean length | 3.0088 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
LS_GLOBAL_PREMIUM_IND_DESC
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
LS_GLOBAL_PROD_FAMILY
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 67.3% |
| Missing (n) | 1997 |
| STOCK | |
|---|---|
| BASEOI | 5 |
| (Missing) |
| Value | Count | Frequency (%) | |
| STOCK | 966 | 32.5% | |
| BASEOI | 5 | < 0.1% | |
| (Missing) | 1997 | 67.3% |
| Max length | 6 |
|---|---|
| Mean length | 3.656 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
LS_GLOBAL_PROD_FAMILY_DESC
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 67.3% |
| Missing (n) | 1997 |
| STOCK | |
|---|---|
| BASE OILS | 5 |
| (Missing) |
| Value | Count | Frequency (%) | |
| STOCK | 966 | 32.5% | |
| BASE OILS | 5 | < 0.1% | |
| (Missing) | 1997 | 67.3% |
| Max length | 9 |
|---|---|
| Mean length | 3.6611 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
LS_GLOBAL_PRODUCT_GROUP
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 67.3% |
| Missing (n) | 1997 |
| OTHER | |
|---|---|
| BOOTH | 5 |
| (Missing) |
| Value | Count | Frequency (%) | |
| OTHER | 966 | 32.5% | |
| BOOTH | 5 | < 0.1% | |
| (Missing) | 1997 | 67.3% |
| Max length | 5 |
|---|---|
| Mean length | 3.6543 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
LS_GLOBAL_PRODUCT_GROUP_DESC
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 67.3% |
| Missing (n) | 1997 |
| OTHER | |
|---|---|
| OTHER BASE OILS | 5 |
| (Missing) |
| Value | Count | Frequency (%) | |
| OTHER | 966 | 32.5% | |
| OTHER BASE OILS | 5 | < 0.1% | |
| (Missing) | 1997 | 67.3% |
| Max length | 15 |
|---|---|
| Mean length | 3.6712 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
LS_GLOBAL_PRODUCT_LINE
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 67.3% |
| Missing (n) | 1996 |
| ADD | |
|---|---|
| BO | 4 |
| CRUDE - EUROPE - NO. SEA | 1 |
| (Missing) |
| Value | Count | Frequency (%) | |
| ADD | 967 | 32.6% | |
| BO | 4 | < 0.1% | |
| CRUDE - EUROPE - NO. SEA | 1 | < 0.1% | |
| (Missing) | 1996 | 67.3% |
| Max length | 24 |
|---|---|
| Mean length | 3.0057 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
LS_GLOBAL_PRODUCT_LINE_DESC
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 67.3% |
| Missing (n) | 1997 |
| Additive | |
|---|---|
| Base Oils | 4 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Additive | 967 | 32.6% | |
| Base Oils | 4 | < 0.1% | |
| (Missing) | 1997 | 67.3% |
| Max length | 9 |
|---|---|
| Mean length | 4.6371 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
LS_GLOBAL_PRODUCT_NUMBER
Categorical
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 67.3% |
| Missing (n) | 1996 |
| 1010B06020 | |
|---|---|
| 3010201040 | 14 |
| 3010202005 | 13 |
| Other values (4) | 6 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 1010B06020 | 939 | 31.6% | |
| 3010201040 | 14 | < 0.1% | |
| 3010202005 | 13 | < 0.1% | |
| 3.0102E+11 | 2 | < 0.1% | |
| 973408 | 2 | < 0.1% | |
| 3010201010 | 1 | < 0.1% | |
| BULK | 1 | < 0.1% | |
| (Missing) | 1996 | 67.3% |
| Max length | 10 |
|---|---|
| Mean length | 5.2877 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
LS_GLOBAL_SYNTHETIC_IND
Constant
This variable is constant and should be ignored for analysis
| Constant value | MIN |
|---|
LS_GLOBAL_SYNTHETIC_IND_DESC
Constant
This variable is constant and should be ignored for analysis
| Constant value | Mineral |
|---|
MATERIAL
Categorical, Unique
| First 5 values |
|---|
| 100008 |
| 100033 |
| 100035 |
| 100038 |
| 100046 |
| Last 5 values |
|---|
| RS_UNDEF_PROD1 |
| RS_UNDEF_PROD2 |
| RS_UNDEF_PROD3 |
| RS_UNDEF_PROD4 |
| RS_UNDEF_PROD5 |
First 5 values
| Value | Count | Frequency (%) | |
| 100008 | 1 | < 0.1% | |
| 100033 | 1 | < 0.1% | |
| 100035 | 1 | < 0.1% | |
| 100038 | 1 | < 0.1% | |
| 100046 | 1 | < 0.1% |
Last 5 values
| Value | Count | Frequency (%) | |
| RS_UNDEF_PROD5 | 1 | < 0.1% | |
| RS_UNDEF_PROD4 | 1 | < 0.1% | |
| RS_UNDEF_PROD3 | 1 | < 0.1% | |
| RS_UNDEF_PROD2 | 1 | < 0.1% | |
| RS_UNDEF_PROD1 | 1 | < 0.1% |
MATERIAL_DEL_IND
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 88.9% |
| Missing (n) | 2639 |
| X | 328 |
|---|---|
| 90000187 | 1 |
| (Missing) |
| Value | Count | Frequency (%) | |
| X | 328 | 11.1% | |
| 90000187 | 1 | < 0.1% | |
| (Missing) | 2639 | 88.9% |
| Max length | 8 |
|---|---|
| Mean length | 2.7807 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
MATERIAL_DESC
Categorical
| Distinct count | 2916 |
|---|---|
| Unique (%) | > 99.9% |
| Missing (%) | < 0.1% |
| Missing (n) | 39 |
| DO NOT USE | 8 |
|---|---|
| STOCK 1202.0BULKMETHYL 12-HYDROXYSTEAR | 2 |
| REBATE BUSINESS CARD | 2 |
| Other values (2912) | |
| (Missing) | 39 |
| Value | Count | Frequency (%) | |
| DO NOT USE | 8 | < 0.1% | |
| STOCK 1202.0BULKMETHYL 12-HYDROXYSTEAR | 2 | < 0.1% | |
| REBATE BUSINESS CARD | 2 | < 0.1% | |
| STOCK 1315.055.1158LBQUINIZARIN | 2 | < 0.1% | |
| STOCK 1087100 KG MOLY DISULFIDE (EAME) | 2 | < 0.1% | |
| STOCK 70229 417LB OLOA 42015 | 2 | < 0.1% | |
| METHANOL | 2 | < 0.1% | |
| FUEL DISCOUNT - GASOLINE | 2 | < 0.1% | |
| STOCK 5932.0BULKDCI-30N. | 1 | < 0.1% | |
| EXXON S15 NO2 DIESEL EFFICIENT WNTR B5 | 1 | < 0.1% | |
| Other values (2905) | 2905 | > 99.9% | |
| (Missing) | 39 | < 0.1% |
| Max length | 40 |
|---|---|
| Mean length | 28.521 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
MATERIAL_DESC_CONCAT
Categorical, Unique
| First 5 values |
|---|
| 100008 STOCK 1335.5NALCO 5403 JET CORR INHIBIT |
| 100033 STOCK 1443.0BULKLZ 948. |
| 100035 STOCK 2216.0BULKLOBASE C4506. |
| 100038 STOCK 0999.0BULKWATER. |
| 100046 PRICE_REF: 89 CONV 3.5%O2 BRANDED. |
| Last 5 values |
|---|
| RS_UNDEF_PROD1 |
| RS_UNDEF_PROD2 |
| RS_UNDEF_PROD3 |
| RS_UNDEF_PROD4 |
| RS_UNDEF_PROD5 |
First 5 values
| Value | Count | Frequency (%) | |
| 100008 STOCK 1335.5NALCO 5403 JET CORR INHIBIT | 1 | < 0.1% | |
| 100033 STOCK 1443.0BULKLZ 948. | 1 | < 0.1% | |
| 100035 STOCK 2216.0BULKLOBASE C4506. | 1 | < 0.1% | |
| 100038 STOCK 0999.0BULKWATER. | 1 | < 0.1% | |
| 100046 PRICE_REF: 89 CONV 3.5%O2 BRANDED. | 1 | < 0.1% |
Last 5 values
| Value | Count | Frequency (%) | |
| RS_UNDEF_PROD5 | 1 | < 0.1% | |
| RS_UNDEF_PROD4 | 1 | < 0.1% | |
| RS_UNDEF_PROD3 | 1 | < 0.1% | |
| RS_UNDEF_PROD2 | 1 | < 0.1% | |
| RS_UNDEF_PROD1 | 1 | < 0.1% |
MATERIAL_DH_UPDATE_TIMESTAMP
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 09:24.0 | |
|---|---|
| 00:03.0 | 2 |
| 37:48.0 | 2 |
| Other values (4) | 4 |
| Value | Count | Frequency (%) | |
| 09:24.0 | 2960 | > 99.9% | |
| 00:03.0 | 2 | < 0.1% | |
| 37:48.0 | 2 | < 0.1% | |
| 11:01.0 | 1 | < 0.1% | |
| 03:35.0 | 1 | < 0.1% | |
| 101313 | 1 | < 0.1% | |
| 02:40.0 | 1 | < 0.1% |
| Max length | 7 |
|---|---|
| Mean length | 6.9997 |
| Min length | 6 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
MATERIAL_DIVISION
Numeric
| Distinct count | 9 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 33 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.1131 |
|---|---|
| Minimum | 2 |
| Maximum | 13 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 2 |
| Median | 2 |
| Q3 | 4 |
| 95-th percentile | 6 |
| Maximum | 13 |
| Range | 11 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 1.6757 |
|---|---|
| Coef of variation | 0.53827 |
| Kurtosis | 6.1142 |
| Mean | 3.1131 |
| MAD | 1.3021 |
| Skewness | 2.1436 |
| Sum | 9137 |
| Variance | 2.8079 |
| Memory size | 23.2 KiB |
| Value | Count | Frequency (%) | |
| 2 | 1716 | 57.8% | |
| 4 | 973 | 32.8% | |
| 8 | 81 | < 0.1% | |
| 6 | 74 | < 0.1% | |
| 9 | 50 | < 0.1% | |
| 5 | 24 | < 0.1% | |
| 13 | 10 | < 0.1% | |
| 3 | 7 | < 0.1% | |
| (Missing) | 33 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2 | 1716 | 57.8% | |
| 3 | 7 | < 0.1% | |
| 4 | 973 | 32.8% | |
| 5 | 24 | < 0.1% | |
| 6 | 74 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 13 | 10 | < 0.1% | |
| 9 | 50 | < 0.1% | |
| 8 | 81 | < 0.1% | |
| 6 | 74 | < 0.1% | |
| 5 | 24 | < 0.1% |
MATERIAL_GROSS_WEIGHT
Categorical
| Distinct count | 344 |
|---|---|
| Unique (%) | 11.6% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| 1 | |
|---|---|
| 850.768 | 335 |
| 1,000 | 206 |
| Other values (340) |
| Value | Count | Frequency (%) | |
| 1 | 455 | 15.3% | |
| 850.768 | 335 | 11.3% | |
| 1,000 | 206 | 6.9% | |
| 0 | 105 | < 0.1% | |
| 878.328 | 76 | < 0.1% | |
| 850 | 70 | < 0.1% | |
| 750 | 69 | < 0.1% | |
| 739.329 | 58 | < 0.1% | |
| 851.606 | 58 | < 0.1% | |
| 746.519 | 54 | < 0.1% | |
| Other values (333) | 1481 | 49.9% |
| Max length | 8 |
|---|---|
| Mean length | 4.782 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
MATERIAL_GROUP
Categorical
| Distinct count | 29 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 36 |
| MOGAS | |
|---|---|
| LSP-ADD | |
| DIESEL | |
| Other values (25) |
| Value | Count | Frequency (%) | |
| MOGAS | 693 | 23.3% | |
| LSP-ADD | 645 | 21.7% | |
| DIESEL | 589 | 19.8% | |
| LSB-ADD | 289 | 9.7% | |
| ZZ-PRICE | 106 | < 0.1% | |
| 3530 | 84 | < 0.1% | |
| PRDENV | 70 | < 0.1% | |
| CLEAN-OTH | 70 | < 0.1% | |
| 3520 | 65 | < 0.1% | |
| GASOIL | 64 | < 0.1% | |
| Other values (18) | 257 | 8.7% |
| Max length | 9 |
|---|---|
| Mean length | 6.0492 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
MATERIAL_GROUP_DESC
Categorical
| Distinct count | 28 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 99 |
| PH3=101010 | |
|---|---|
| Lube Additive Pack | |
| PH3=101020 | |
| Other values (24) |
| Value | Count | Frequency (%) | |
| PH3=101010 | 693 | 23.3% | |
| Lube Additive Pack | 645 | 21.7% | |
| PH3=101020 | 589 | 19.8% | |
| Lube Additive Bulk | 289 | 9.7% | |
| PH3=101010 PRDNN=PRICE REF: | 106 | < 0.1% | |
| Fuel Adds Other (HitecKerobit TPKerobit BPDColours/dyes) | 84 | < 0.1% | |
| PH3=706015 | 70 | < 0.1% | |
| PH3=602030 | 70 | < 0.1% | |
| Gasoline Additives (incl. Lead Compound) | 65 | < 0.1% | |
| PH3=101060 | 64 | < 0.1% | |
| Other values (17) | 194 | 6.5% | |
| (Missing) | 99 | < 0.1% |
| Max length | 60 |
|---|---|
| Mean length | 15.068 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
MATERIAL_KEY
Categorical, Unique
| First 5 values |
|---|
| 100008 |
| 100033 |
| 100035 |
| 100038 |
| 100046 |
| Last 5 values |
|---|
| RS_UNDEF_PROD1 |
| RS_UNDEF_PROD2 |
| RS_UNDEF_PROD3 |
| RS_UNDEF_PROD4 |
| RS_UNDEF_PROD5 |
First 5 values
| Value | Count | Frequency (%) | |
| 100008 | 1 | < 0.1% | |
| 100033 | 1 | < 0.1% | |
| 100035 | 1 | < 0.1% | |
| 100038 | 1 | < 0.1% | |
| 100046 | 1 | < 0.1% |
Last 5 values
| Value | Count | Frequency (%) | |
| RS_UNDEF_PROD5 | 1 | < 0.1% | |
| RS_UNDEF_PROD4 | 1 | < 0.1% | |
| RS_UNDEF_PROD3 | 1 | < 0.1% | |
| RS_UNDEF_PROD2 | 1 | < 0.1% | |
| RS_UNDEF_PROD1 | 1 | < 0.1% |
MATERIAL_MD
Categorical, Unique
| First 5 values |
|---|
| 100008 |
| 100033 |
| 100035 |
| 100038 |
| 100046 |
| Last 5 values |
|---|
| RS_UNDEF_PROD1 |
| RS_UNDEF_PROD2 |
| RS_UNDEF_PROD3 |
| RS_UNDEF_PROD4 |
| RS_UNDEF_PROD5 |
First 5 values
| Value | Count | Frequency (%) | |
| 100008 | 1 | < 0.1% | |
| 100033 | 1 | < 0.1% | |
| 100035 | 1 | < 0.1% | |
| 100038 | 1 | < 0.1% | |
| 100046 | 1 | < 0.1% |
Last 5 values
| Value | Count | Frequency (%) | |
| RS_UNDEF_PROD5 | 1 | < 0.1% | |
| RS_UNDEF_PROD4 | 1 | < 0.1% | |
| RS_UNDEF_PROD3 | 1 | < 0.1% | |
| RS_UNDEF_PROD2 | 1 | < 0.1% | |
| RS_UNDEF_PROD1 | 1 | < 0.1% |
MATERIAL_NET_WEIGHT
Categorical
| Distinct count | 247 |
|---|---|
| Unique (%) | 8.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 1 | |
|---|---|
| 850.768 | |
| 1,000 | 200 |
| Other values (244) |
| Value | Count | Frequency (%) | |
| 1 | 966 | 32.5% | |
| 850.768 | 335 | 11.3% | |
| 1,000 | 200 | 6.7% | |
| 0 | 112 | < 0.1% | |
| 878.328 | 76 | < 0.1% | |
| 850 | 70 | < 0.1% | |
| 750 | 69 | < 0.1% | |
| 851.606 | 58 | < 0.1% | |
| 739.329 | 58 | < 0.1% | |
| 746.519 | 54 | < 0.1% | |
| Other values (237) | 970 | 32.7% |
| Max length | 8 |
|---|---|
| Mean length | 4.1223 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
MATERIAL_PROD_FAMILY_BLENDED
Categorical
| Distinct count | 21 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 49.2% |
| Missing (n) | 1461 |
| ULSD | |
|---|---|
| PREMCBOB | 153 |
| REGCBOB | 150 |
| Other values (17) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| ULSD | 569 | 19.2% | |
| PREMCBOB | 153 | 5.2% | |
| REGCBOB | 150 | 5.1% | |
| MIDCBOB | 93 | < 0.1% | |
| REGRFG | 88 | < 0.1% | |
| PREMRFG | 70 | < 0.1% | |
| DISTBLENDSTK | 58 | < 0.1% | |
| MIDRFG | 49 | < 0.1% | |
| REGCBOBSUM | 48 | < 0.1% | |
| ULSD1 | 45 | < 0.1% | |
| Other values (10) | 184 | 6.2% | |
| (Missing) | 1461 | 49.2% |
| Max length | 13 |
|---|---|
| Mean length | 4.621 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
MATERIAL_PROD_FAMILY_BLENDED_DESC
Categorical
| Distinct count | 19 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 49.3% |
| Missing (n) | 1464 |
| ULSD | |
|---|---|
| Premium CBOB | 153 |
| Regular CBOB | 150 |
| Other values (15) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| ULSD | 569 | 19.2% | |
| Premium CBOB | 153 | 5.2% | |
| Regular CBOB | 150 | 5.1% | |
| Mid-Grade CBOB | 93 | < 0.1% | |
| Regular RFG | 88 | < 0.1% | |
| Premium RFG | 70 | < 0.1% | |
| DISTILLATE BLENDSTOCK | 58 | < 0.1% | |
| Mid-Grade RFG | 49 | < 0.1% | |
| Regular CBOB SUMMER GRADE | 48 | < 0.1% | |
| ULSD1 | 45 | < 0.1% | |
| Other values (8) | 181 | 6.1% | |
| (Missing) | 1464 | 49.3% |
| Max length | 27 |
|---|---|
| Mean length | 6.5081 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
MATERIAL_PROD_FAMILY_BLENDED_GROUP
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 49.3% |
| Missing (n) | 1464 |
| Mogas | |
|---|---|
| Distillate | |
| Components | 61 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Mogas | 721 | 24.3% | |
| Distillate | 689 | 23.2% | |
| Components | 61 | < 0.1% | |
| Jet | 33 | < 0.1% | |
| (Missing) | 1464 | 49.3% |
| Max length | 10 |
|---|---|
| Mean length | 5.2547 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
MATERIAL_PROD_FAMILY_UNBLENDED
Categorical
| Distinct count | 16 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 49.3% |
| Missing (n) | 1462 |
| ULSD | |
|---|---|
| REGCBOB | 198 |
| PREMCBOB | 191 |
| Other values (12) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| ULSD | 569 | 19.2% | |
| REGCBOB | 198 | 6.7% | |
| PREMCBOB | 191 | 6.4% | |
| # | 170 | 5.7% | |
| REGRFG | 88 | < 0.1% | |
| PREMRFG | 70 | < 0.1% | |
| DISTBLENDSTK | 58 | < 0.1% | |
| ULSD1 | 45 | < 0.1% | |
| HEATOIL | 37 | < 0.1% | |
| JET | 33 | < 0.1% | |
| Other values (5) | 47 | < 0.1% | |
| (Missing) | 1462 | 49.3% |
| Max length | 13 |
|---|---|
| Mean length | 4.1772 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
MATERIAL_PROD_FAMILY_UNBLENDED_DESC
Categorical
| Distinct count | 15 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 49.3% |
| Missing (n) | 1464 |
| ULSD | |
|---|---|
| Regular CBOB | 198 |
| Premium CBOB | 191 |
| Other values (11) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| ULSD | 569 | 19.2% | |
| Regular CBOB | 198 | 6.7% | |
| Premium CBOB | 191 | 6.4% | |
| # | 170 | 5.7% | |
| Regular RFG | 88 | < 0.1% | |
| Premium RFG | 70 | < 0.1% | |
| DISTILLATE BLENDSTOCK | 58 | < 0.1% | |
| ULSD1 | 45 | < 0.1% | |
| Heating Oil | 37 | < 0.1% | |
| Jet | 33 | < 0.1% | |
| Other values (4) | 45 | < 0.1% | |
| (Missing) | 1464 | 49.3% |
| Max length | 21 |
|---|---|
| Mean length | 5.2807 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
MATERIAL_PROD_FAMILY_UNBLENDED_GROUP
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 49.3% |
| Missing (n) | 1464 |
| Distillate | |
|---|---|
| Mogas | |
| # | 170 |
| Other values (2) | 94 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Distillate | 689 | 23.2% | |
| Mogas | 551 | 18.6% | |
| # | 170 | 5.7% | |
| Components | 61 | < 0.1% | |
| Jet | 33 | < 0.1% | |
| (Missing) | 1464 | 49.3% |
| Max length | 10 |
|---|---|
| Mean length | 5.0256 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | True |
MATERIAL_SOURCE_SYSTEM
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
MATERIAL_STCC
Numeric
| Distinct count | 31 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 81.1% |
| Missing (n) | 2407 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.3802e+06 |
|---|---|
| Minimum | 1.4716e+06 |
| Maximum | 4.9616e+06 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1.4716e+06 |
|---|---|
| 5-th percentile | 2.8999e+06 |
| Q1 | 2.9e+06 |
| Median | 2.9113e+06 |
| Q3 | 2.9912e+06 |
| 95-th percentile | 4.9122e+06 |
| Maximum | 4.9616e+06 |
| Range | 3.49e+06 |
| Interquartile range | 91239 |
Descriptive statistics
| Standard deviation | 8.5606e+05 |
|---|---|
| Coef of variation | 0.25326 |
| Kurtosis | -0.44842 |
| Mean | 3.3802e+06 |
| MAD | 7.2558e+05 |
| Skewness | 1.2128 |
| Sum | 1.8963e+09 |
| Variance | 7.3284e+11 |
| Memory size | 23.2 KiB |
| Value | Count | Frequency (%) | |
| 2.9114e+06 | 98 | < 0.1% | |
| 2.9113e+06 | 93 | < 0.1% | |
| 2.8999e+06 | 84 | < 0.1% | |
| 4.9082e+06 | 84 | < 0.1% | |
| 2.9e+06 | 79 | < 0.1% | |
| 4.9122e+06 | 40 | < 0.1% | |
| 2.9112e+06 | 34 | < 0.1% | |
| 2.9912e+06 | 8 | < 0.1% | |
| 2.9118e+06 | 8 | < 0.1% | |
| 2.9111e+06 | 5 | < 0.1% | |
| Other values (20) | 28 | < 0.1% | |
| (Missing) | 2407 | 81.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.4716e+06 | 1 | < 0.1% | |
| 2.8133e+06 | 1 | < 0.1% | |
| 2.8184e+06 | 1 | < 0.1% | |
| 2.8211e+06 | 1 | < 0.1% | |
| 2.8999e+06 | 84 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 4.9616e+06 | 1 | < 0.1% | |
| 4.9602e+06 | 1 | < 0.1% | |
| 4.921e+06 | 1 | < 0.1% | |
| 4.9153e+06 | 1 | < 0.1% | |
| 4.9148e+06 | 1 | < 0.1% |
MATERIAL_STCC_DESC
Categorical
| Distinct count | 30 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 81.1% |
| Missing (n) | 2407 |
| PETROLEUM LUBRICATING OIL | 98 |
|---|---|
| PETROLEUM DISTILLATE FUEL OIL DIESEL OIL OR GAS OIL NOT SUITABLE FOR ILLUMINATING PURPOSES | 93 |
| GASOLINE | 84 |
| Other values (26) | 286 |
| (Missing) |
| Value | Count | Frequency (%) | |
| PETROLEUM LUBRICATING OIL | 98 | < 0.1% | |
| PETROLEUM DISTILLATE FUEL OIL DIESEL OIL OR GAS OIL NOT SUITABLE FOR ILLUMINATING PURPOSES | 93 | < 0.1% | |
| GASOLINE | 84 | < 0.1% | |
| ADDITIVES FUEL OIL GASOLINE OR LUBRICATING OIL CONTAINING LESS THAN 50 PERCENT BY WEIGHT OF PETROLEUM | 84 | < 0.1% | |
| CHEMICALS NEC | 79 | < 0.1% | |
| DIESEL FUEL | 40 | < 0.1% | |
| GASOLINE NEC | 34 | < 0.1% | |
| PETROLEUM OIL ADDITIVE CONTAINING MORE THAN 50 PERCENT BY WEIGHT OF PETROLEUM | 8 | < 0.1% | |
| OIL PETROLEUM NEC | 8 | < 0.1% | |
| JET FUEL | 5 | < 0.1% | |
| Other values (19) | 28 | < 0.1% | |
| (Missing) | 2407 | 81.1% |
| Max length | 101 |
|---|---|
| Mean length | 10.424 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
MATERIAL_TYPE
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 32 |
| HALB | |
|---|---|
| DIEN | 67 |
| SERV | 6 |
| (Missing) | 32 |
| Value | Count | Frequency (%) | |
| HALB | 2863 | > 99.9% | |
| DIEN | 67 | < 0.1% | |
| SERV | 6 | < 0.1% | |
| (Missing) | 32 | < 0.1% |
| Max length | 4 |
|---|---|
| Mean length | 3.9892 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
MATERIAL_TYPE_DESC
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 32 |
| Semifinished product | |
|---|---|
| Service | 67 |
| Brand Fund Agreement | 6 |
| (Missing) | 32 |
| Value | Count | Frequency (%) | |
| Semifinished product | 2862 | > 99.9% | |
| Service | 67 | < 0.1% | |
| Brand Fund Agreement | 6 | < 0.1% | |
| 896.1 | 1 | < 0.1% | |
| (Missing) | 32 | < 0.1% |
| Max length | 20 |
|---|---|
| Mean length | 19.518 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
MATERIAL_UOM
Categorical
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 32 |
| M15 | |
|---|---|
| KG | |
| EA | 79 |
| Other values (4) | 145 |
| Value | Count | Frequency (%) | |
| M15 | 1747 | 58.9% | |
| KG | 965 | 32.5% | |
| EA | 79 | < 0.1% | |
| TO | 73 | < 0.1% | |
| D43 | 70 | < 0.1% | |
| BBL | 1 | < 0.1% | |
| UGL | 1 | < 0.1% | |
| (Missing) | 32 | < 0.1% |
| Max length | 3 |
|---|---|
| Mean length | 2.6237 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
MATERIAL_VOL
Categorical
| Distinct count | 352 |
|---|---|
| Unique (%) | 11.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 1,000 | |
|---|---|
| 0 | 112 |
| 1.113 | 37 |
| Other values (349) |
| Value | Count | Frequency (%) | |
| 1,000 | 1788 | 60.2% | |
| 0 | 112 | < 0.1% | |
| 1.113 | 37 | < 0.1% | |
| 1 | 20 | < 0.1% | |
| 3.785 | 17 | < 0.1% | |
| 1.043 | 15 | < 0.1% | |
| 1.001 | 13 | < 0.1% | |
| 1.084 | 12 | < 0.1% | |
| 0.973 | 12 | < 0.1% | |
| 1,009.08 | 11 | < 0.1% | |
| Other values (342) | 931 | 31.4% |
| Max length | 20 |
|---|---|
| Mean length | 4.8706 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
PROD_HIER
Categorical
| Distinct count | 55 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 71 |
| 1010B06020 | |
|---|---|
| 10102080 | |
| 10102015 | 209 |
| Other values (51) |
| Value | Count | Frequency (%) | |
| 1010B06020 | 939 | 31.6% | |
| 10102080 | 373 | 12.6% | |
| 10102015 | 209 | 7.0% | |
| 1010B06010 | 170 | 5.7% | |
| 10101050 | 164 | 5.5% | |
| 10101010 | 149 | 5.0% | |
| 10101055 | 131 | < 0.1% | |
| 10101015 | 129 | < 0.1% | |
| 10101035 | 103 | < 0.1% | |
| 70601510 | 67 | < 0.1% | |
| Other values (44) | 463 | 15.6% | |
| (Missing) | 71 | < 0.1% |
| Max length | 14 |
|---|---|
| Mean length | 8.5745 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
PROD_LVL1
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 71 |
| Fin.Petr Prod ex Lu | |
|---|---|
| Non-Petroleum | 104 |
| Raw materials/Unfin. | 81 |
| (Missing) | 71 |
| Value | Count | Frequency (%) | |
| Fin.Petr Prod ex Lu | 2679 | 90.3% | |
| Non-Petroleum | 104 | < 0.1% | |
| Raw materials/Unfin. | 81 | < 0.1% | |
| LUBE BASE OILS | 33 | < 0.1% | |
| (Missing) | 71 | < 0.1% |
| Max length | 20 |
|---|---|
| Mean length | 18.379 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
PROD_LVL1_NO
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 71 |
| 10 | |
|---|---|
| 70 | 104 |
| 60 | 81 |
| (Missing) | 71 |
| Value | Count | Frequency (%) | |
| 10 | 2679 | 90.3% | |
| 70 | 104 | < 0.1% | |
| 60 | 81 | < 0.1% | |
| 30 | 33 | < 0.1% | |
| (Missing) | 71 | < 0.1% |
| Max length | 4 |
|---|---|
| Mean length | 3.9761 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
PROD_LVL2
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 105 |
| CP&S ex Lubes | |
|---|---|
| Feed/Blendst. clean | 80 |
| Other Non-Petroleum | 70 |
| Other values (3) | 85 |
| (Missing) | 105 |
| Value | Count | Frequency (%) | |
| CP&S ex Lubes | 2628 | 88.5% | |
| Feed/Blendst. clean | 80 | < 0.1% | |
| Other Non-Petroleum | 70 | < 0.1% | |
| Fuel Oils | 51 | < 0.1% | |
| BASE OILS | 33 | < 0.1% | |
| Crude | 1 | < 0.1% | |
| (Missing) | 105 | < 0.1% |
| Max length | 19 |
|---|---|
| Mean length | 12.834 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
PROD_LVL2_NO
Highly correlated
This variable is highly correlated with PROD_LVL1_NO and should be ignored for analysis
| Correlation | 0.99999 |
|---|
PROD_LVL3
Categorical
| Distinct count | 14 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 105 |
| Chemicals | |
|---|---|
| Motor Gasoline | |
| Diesel | |
| Other values (10) | |
| (Missing) | 105 |
| Value | Count | Frequency (%) | |
| Chemicals | 1114 | 37.5% | |
| Motor Gasoline | 749 | 25.2% | |
| Diesel | 637 | 21.5% | |
| Other clean fd/blst | 80 | < 0.1% | |
| Fuels Env Credits | 70 | < 0.1% | |
| Gasoil - Land | 64 | < 0.1% | |
| Fuel Oil - Marine | 51 | < 0.1% | |
| NON-XOM MAN BASEOILS | 33 | < 0.1% | |
| Jet | 25 | < 0.1% | |
| Gasoil - Marine | 18 | < 0.1% | |
| Other values (3) | 22 | < 0.1% | |
| (Missing) | 105 | < 0.1% |
| Max length | 20 |
|---|---|
| Mean length | 10.239 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
PROD_LVL3_NO
Categorical
| Distinct count | 14 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 105 |
| 0000001010B0 | |
|---|---|
| 101010 | |
| 101020 | |
| Other values (10) | |
| (Missing) | 105 |
| Value | Count | Frequency (%) | |
| 0000001010B0 | 1114 | 37.5% | |
| 101010 | 749 | 25.2% | |
| 101020 | 637 | 21.5% | |
| 602030 | 80 | < 0.1% | |
| 706015 | 70 | < 0.1% | |
| 101060 | 64 | < 0.1% | |
| 102020 | 51 | < 0.1% | |
| 301020 | 33 | < 0.1% | |
| 101040 | 25 | < 0.1% | |
| 101065 | 18 | < 0.1% | |
| Other values (3) | 22 | < 0.1% | |
| (Missing) | 105 | < 0.1% |
| Max length | 12 |
|---|---|
| Mean length | 8.1701 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
PROD_LVL4
Categorical
| Distinct count | 46 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 118 |
| Additives | |
|---|---|
| Regular ADO with Bio | |
| Regular ADO | 209 |
| Other values (42) |
| Value | Count | Frequency (%) | |
| Additives | 1109 | 37.4% | |
| Regular ADO with Bio | 373 | 12.6% | |
| Regular ADO | 209 | 7.0% | |
| Regular UL | 164 | 5.5% | |
| Premium UL | 149 | 5.0% | |
| Regular UL w Eth | 131 | < 0.1% | |
| Premium UL with Eth | 129 | < 0.1% | |
| Intermediate UL w Eth | 103 | < 0.1% | |
| RINS | 67 | < 0.1% | |
| Intermediate UL | 66 | < 0.1% | |
| Other values (35) | 350 | 11.8% | |
| (Missing) | 118 | < 0.1% |
| Max length | 25 |
|---|---|
| Mean length | 12.174 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
PROD_LVL4_NO
Categorical
| Distinct count | 47 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 118 |
| 00001010B060 | |
|---|---|
| 10102080 | |
| 10102015 | 209 |
| Other values (43) |
| Value | Count | Frequency (%) | |
| 00001010B060 | 1109 | 37.4% | |
| 10102080 | 373 | 12.6% | |
| 10102015 | 209 | 7.0% | |
| 10101050 | 164 | 5.5% | |
| 10101010 | 149 | 5.0% | |
| 10101055 | 131 | < 0.1% | |
| 10101015 | 129 | < 0.1% | |
| 10101035 | 103 | < 0.1% | |
| 70601510 | 67 | < 0.1% | |
| 10101030 | 66 | < 0.1% | |
| Other values (36) | 350 | 11.8% | |
| (Missing) | 118 | < 0.1% |
| Max length | 12 |
|---|---|
| Mean length | 9.3187 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
PROD_LVL5
Categorical
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 61.5% |
| Missing (n) | 1826 |
| Lubes Additives | |
|---|---|
| Fuels Additives | 170 |
| OTHER GROUP I | 15 |
| Other values (4) | 18 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Lubes Additives | 939 | 31.6% | |
| Fuels Additives | 170 | 5.7% | |
| OTHER GROUP I | 15 | < 0.1% | |
| OTHER GROUP II | 13 | < 0.1% | |
| BRIGHTSTOCK | 2 | < 0.1% | |
| LIGHT NEUTRAL | 2 | < 0.1% | |
| HEAVY NEUTRAL | 1 | < 0.1% | |
| (Missing) | 1826 | 61.5% |
| Max length | 15 |
|---|---|
| Mean length | 7.598 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
PROD_LVL5_NO
Categorical
| Distinct count | 9 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 61.5% |
| Missing (n) | 1825 |
| 001010B06020 | |
|---|---|
| 001010B06010 | 170 |
| 3010201040 | 15 |
| Other values (5) | 19 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 001010B06020 | 939 | 31.6% | |
| 001010B06010 | 170 | 5.7% | |
| 3010201040 | 15 | < 0.1% | |
| 3010202005 | 13 | < 0.1% | |
| 3010201010 | 2 | < 0.1% | |
| 3010201030 | 2 | < 0.1% | |
| 3010201020 | 1 | < 0.1% | |
| NorthSea | 1 | < 0.1% | |
| (Missing) | 1825 | 61.5% |
| Max length | 12 |
|---|---|
| Mean length | 6.4427 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
PROD_LVL6
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | > 99.9% |
| Missing (n) | 2966 |
| Chevron Neutral Oil 220R | 1 |
|---|---|
| AMERICAS SN 100 LV | 1 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Chevron Neutral Oil 220R | 1 | < 0.1% | |
| AMERICAS SN 100 LV | 1 | < 0.1% | |
| (Missing) | 2966 | > 99.9% |
| Max length | 24 |
|---|---|
| Mean length | 3.0121 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
PROD_LVL6_NO
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
PROMIS_SHELF_LIFE
Categorical
| Distinct count | 22 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 720 | |
| 1,440 | 97 |
| Other values (19) | 368 |
| Value | Count | Frequency (%) | |
| 0 | 2068 | 69.7% | |
| 720 | 435 | 14.7% | |
| 1,440 | 97 | < 0.1% | |
| 1,080 | 87 | < 0.1% | |
| 3,520 | 74 | < 0.1% | |
| 360 | 68 | < 0.1% | |
| 1,800 | 66 | < 0.1% | |
| 540 | 22 | < 0.1% | |
| 730 | 12 | < 0.1% | |
| 1,620 | 9 | < 0.1% | |
| Other values (12) | 30 | < 0.1% |
| Max length | 5 |
|---|---|
| Mean length | 1.8332 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
SHIPNET_COMMODITY
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
TRANSPORT_GROUP
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 113 |
| RBLK | |
|---|---|
| RPCK | |
| (Missing) | 113 |
| Value | Count | Frequency (%) | |
| RBLK | 2178 | 73.4% | |
| RPCK | 677 | 22.8% | |
| (Missing) | 113 | < 0.1% |
| Max length | 4 |
|---|---|
| Mean length | 3.9619 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
VOL_UOM_CODE
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 112 |
| L15 | |
|---|---|
| L | 1 |
| 1,000 | 1 |
| (Missing) | 112 |
| Value | Count | Frequency (%) | |
| L15 | 2854 | > 99.9% | |
| L | 1 | < 0.1% | |
| 1,000 | 1 | < 0.1% | |
| (Missing) | 112 | < 0.1% |
| Max length | 5 |
|---|---|
| Mean length | 3 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
VR_CLASS_LVL1
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 6.5% |
| Missing (n) | 194 |
| VOLUME REPORTING | |
|---|---|
| VR9999 | 1 |
| (Missing) | 194 |
| Value | Count | Frequency (%) | |
| VOLUME REPORTING | 2773 | 93.4% | |
| VR9999 | 1 | < 0.1% | |
| (Missing) | 194 | 6.5% |
| Max length | 16 |
|---|---|
| Mean length | 15.147 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
VR_CLASS_LVL1_NO
Constant
This variable is constant and should be ignored for analysis
| Constant value | VR9999 |
|---|
VR_CLASS_LVL2
Categorical
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 6.5% |
| Missing (n) | 194 |
| LUBES | |
|---|---|
| MOGAS | |
| DISTILLATES | |
| Other values (4) | 149 |
| (Missing) |
| Value | Count | Frequency (%) | |
| LUBES | 964 | 32.5% | |
| MOGAS | 845 | 28.5% | |
| DISTILLATES | 816 | 27.5% | |
| OTHER | 95 | < 0.1% | |
| OTHER PRODUCTS | 33 | < 0.1% | |
| GAS LIQUIDS | 20 | < 0.1% | |
| VR2699 | 1 | < 0.1% | |
| (Missing) | 194 | 6.5% |
| Max length | 14 |
|---|---|
| Mean length | 6.6597 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
VR_CLASS_LVL2_NO
Categorical
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 6.5% |
| Missing (n) | 194 |
| VR3999 | |
|---|---|
| VR5999 | |
| VR6999 | |
| Other values (4) | 149 |
| (Missing) |
| Value | Count | Frequency (%) | |
| VR3999 | 964 | 32.5% | |
| VR5999 | 845 | 28.5% | |
| VR6999 | 816 | 27.5% | |
| VR8999 | 95 | < 0.1% | |
| VR7999 | 33 | < 0.1% | |
| VR4999 | 20 | < 0.1% | |
| VOLUME REPORTING | 1 | < 0.1% | |
| (Missing) | 194 | 6.5% |
| Max length | 16 |
|---|---|
| Mean length | 5.8073 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
VR_CLASS_LVL3
Categorical
| Distinct count | 22 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 6.5% |
| Missing (n) | 194 |
| L06 LUBE-ADDITIVES | |
|---|---|
| P09 FINISHED DISTILLATES | |
| P05 UNLEADED | |
| Other values (18) |
| Value | Count | Frequency (%) | |
| L06 LUBE-ADDITIVES | 891 | 30.0% | |
| P09 FINISHED DISTILLATES | 717 | 24.2% | |
| P05 UNLEADED | 293 | 9.9% | |
| P03 SUPER | 264 | 8.9% | |
| P04 SPECIAL | 174 | 5.9% | |
| P06 OTHER MOGAS | 109 | < 0.1% | |
| P10 OTHER DISTILLATE | 99 | < 0.1% | |
| P13 BY PRODUCTS | 55 | < 0.1% | |
| L01 LUBE-BLENDSTOCKS | 52 | < 0.1% | |
| P14 REFINERY INPUT | 37 | < 0.1% | |
| Other values (11) | 83 | < 0.1% | |
| (Missing) | 194 | 6.5% |
| Max length | 32 |
|---|---|
| Mean length | 16.626 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
VR_CLASS_LVL3_NO
Categorical
| Distinct count | 22 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 6.5% |
| Missing (n) | 194 |
| VR3499 | |
|---|---|
| VR6099 | |
| VR5299 | |
| Other values (18) |
| Value | Count | Frequency (%) | |
| VR3499 | 891 | 30.0% | |
| VR6099 | 717 | 24.2% | |
| VR5299 | 293 | 9.9% | |
| VR5099 | 264 | 8.9% | |
| VR5199 | 174 | 5.9% | |
| VR5499 | 109 | < 0.1% | |
| VR6199 | 99 | < 0.1% | |
| VR8099 | 55 | < 0.1% | |
| VR3099 | 52 | < 0.1% | |
| VR8599 | 37 | < 0.1% | |
| Other values (11) | 83 | < 0.1% | |
| (Missing) | 194 | 6.5% |
| Max length | 6 |
|---|---|
| Mean length | 5.8036 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
VR_CLASS_LVL4
Categorical
| Distinct count | 101 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 6.5% |
| Missing (n) | 194 |
| LUBE ADDITIVES | |
|---|---|
| S15 MV NO.2 DSL | |
| ADDITIVES | 172 |
| Other values (97) | |
| (Missing) | 194 |
| Value | Count | Frequency (%) | |
| LUBE ADDITIVES | 891 | 30.0% | |
| S15 MV NO.2 DSL | 369 | 12.4% | |
| ADDITIVES | 172 | 5.8% | |
| S15 NRLM No.2 DSL | 161 | 5.4% | |
| UNLEADED CONVENTIONAL | 97 | < 0.1% | |
| SUPER CONVENTIONAL | 92 | < 0.1% | |
| SPECIAL CONVENTIONAL | 57 | < 0.1% | |
| BASESTOCK - FINISHED | 52 | < 0.1% | |
| RESID FUEL | 49 | < 0.1% | |
| SUPER OXYW/ETHANOL | 48 | < 0.1% | |
| Other values (90) | 786 | 26.5% | |
| (Missing) | 194 | 6.5% |
| Max length | 40 |
|---|---|
| Mean length | 16.033 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
VR_CLASS_LVL4_NO
Categorical
| Distinct count | 102 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 6.5% |
| Missing (n) | 194 |
| VR3401 | |
|---|---|
| VR6013 | |
| VR6018 | 161 |
| Other values (98) | |
| (Missing) | 194 |
| Value | Count | Frequency (%) | |
| VR3401 | 891 | 30.0% | |
| VR6013 | 369 | 12.4% | |
| VR6018 | 161 | 5.4% | |
| VR5402 | 109 | < 0.1% | |
| VR5201 | 97 | < 0.1% | |
| VR5001 | 92 | < 0.1% | |
| VR6101 | 63 | < 0.1% | |
| VR5101 | 57 | < 0.1% | |
| VR3001 | 52 | < 0.1% | |
| VR8001 | 49 | < 0.1% | |
| Other values (91) | 834 | 28.1% | |
| (Missing) | 194 | 6.5% |
| Max length | 20 |
|---|---|
| Mean length | 5.8086 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
WEIGHT_UOM_CODE
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 32 |
| KG | |
|---|---|
| L15 | 1 |
| (Missing) | 32 |
| Value | Count | Frequency (%) | |
| KG | 2935 | > 99.9% | |
| L15 | 1 | < 0.1% | |
| (Missing) | 32 | < 0.1% |
| Max length | 3 |
|---|---|
| Mean length | 2.0111 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Matrix
Count
Heatmap
Dendrogram
First rows
| ADDITIVES_BRANDED_DIESEL_IND | ADDITIVES_BRANDED_GASOLINE_IND | ADDITIVES_DYE_IND | ADDITIVES_LUBRICITY_IND | ADDITIVES_UNBRANDED_GASOLINE_IND | CF3030_LINE_CODE | CF3030_LINE_DESC | CF3030_LINE_LVL1_DESC | CF3030_LINE_LVL2_DESC | CONTAINER_REQUIREMENTS | DH_SRC | EMAPSS_MATERIAL | FUELS_BASE_IND | GLOB_PROD_LVL1 | GLOB_PROD_LVL1_NO | GLOB_PROD_LVL2 | GLOB_PROD_LVL2_NO | GLOB_PROD_LVL3 | GLOB_PROD_LVL3_NO | GLOB_PROD_LVL4 | GLOB_PROD_LVL4_NO | GOM_MATERIAL | GPAQS_CMCS_CODE | GPAQS_MATERIAL_NAME | LS_GLOBAL_BRAND | LS_GLOBAL_BRAND_DESC | LS_GLOBAL_BULK_PACK_ID | LS_GLOBAL_PACKAGE_GROUP | LS_GLOBAL_PREMIUM_IND | LS_GLOBAL_PREMIUM_IND_DESC | LS_GLOBAL_PROD_FAMILY | LS_GLOBAL_PROD_FAMILY_DESC | LS_GLOBAL_PRODUCT_GROUP | LS_GLOBAL_PRODUCT_GROUP_DESC | LS_GLOBAL_PRODUCT_LINE | LS_GLOBAL_PRODUCT_LINE_DESC | LS_GLOBAL_PRODUCT_NUMBER | LS_GLOBAL_SYNTHETIC_IND | LS_GLOBAL_SYNTHETIC_IND_DESC | MATERIAL | MATERIAL_DEL_IND | MATERIAL_DESC | MATERIAL_DESC_CONCAT | MATERIAL_DH_UPDATE_TIMESTAMP | MATERIAL_DIVISION | MATERIAL_GROSS_WEIGHT | MATERIAL_GROUP | MATERIAL_GROUP_DESC | MATERIAL_KEY | MATERIAL_MD | MATERIAL_NET_WEIGHT | MATERIAL_PROD_FAMILY_BLENDED | MATERIAL_PROD_FAMILY_BLENDED_DESC | MATERIAL_PROD_FAMILY_BLENDED_GROUP | MATERIAL_PROD_FAMILY_UNBLENDED | MATERIAL_PROD_FAMILY_UNBLENDED_DESC | MATERIAL_PROD_FAMILY_UNBLENDED_GROUP | MATERIAL_SOURCE_SYSTEM | MATERIAL_STCC | MATERIAL_STCC_DESC | MATERIAL_TYPE | MATERIAL_TYPE_DESC | MATERIAL_UOM | MATERIAL_VOL | PROD_HIER | PROD_LVL1 | PROD_LVL1_NO | PROD_LVL2 | PROD_LVL2_NO | PROD_LVL3 | PROD_LVL3_NO | PROD_LVL4 | PROD_LVL4_NO | PROD_LVL5 | PROD_LVL5_NO | PROD_LVL6 | PROD_LVL6_NO | PROMIS_SHELF_LIFE | SHIPNET_COMMODITY | TRANSPORT_GROUP | VOL_UOM_CODE | VR_CLASS_LVL1 | VR_CLASS_LVL1_NO | VR_CLASS_LVL2 | VR_CLASS_LVL2_NO | VR_CLASS_LVL3 | VR_CLASS_LVL3_NO | VR_CLASS_LVL4 | VR_CLASS_LVL4_NO | WEIGHT_UOM_CODE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | NaN | NaN | NaN | NaN | NaN | 40.0 | Motor Gasoline | Products | Fuels | NaN | STRIPES_AM | NaN | Base | Refy Oth External Input | 20 | Non-Proc Refy Inputs | 18 | Additives | 38 | Fuels Additives | 381 | NaN | NaN | NaN | NaN | NaN | BULK | BULK | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 100008 | NaN | STOCK 1335.5NALCO 5403 JET CORR INHIBIT | 100008 STOCK 1335.5NALCO 5403 JET CORR INHIBIT | 09:24.0 | 2.0 | 874.733 | 3530 | Fuel Adds Other (HitecKerobit TPKerobit BPDCol... | 100008 | 100008 | 874.733 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | HALB | Semifinished product | M15 | 1,000 | 1010B06010 | Fin.Petr Prod ex Lu | 10.0 | CP&S ex Lubes | 1010.0 | Chemicals | 0000001010B0 | Additives | 00001010B060 | Fuels Additives | 001010B06010 | NaN | NaN | 0 | NaN | RBLK | L15 | VOLUME REPORTING | VR9999 | MOGAS | VR5999 | P06 OTHER MOGAS | VR5499 | ADDITIVES | VR5402 | KG |
| 1 | NaN | NaN | NaN | NaN | NaN | 260.0 | Finished Lubes | Products | Lubes | NaN | STRIPES_AM | 100033 | Base | Refy Oth External Input | 20 | Non-Proc Refy Inputs | 18 | Additives | 38 | Fuels Additives | 381 | 90039041.0 | 970654 | LUBRIZOL 948 | XOM | ExxonMobil | BULK | BULK | NON | None | STOCK | STOCK | OTHER | OTHER | ADD | Additive | 1010B06020 | MIN | Mineral | 100033 | NaN | STOCK 1443.0BULKLZ 948. | 100033 STOCK 1443.0BULKLZ 948. | 09:24.0 | 4.0 | 1 | LSB-ADD | Lube Additive Bulk | 100033 | 100033 | 1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2899885.0 | ADDITIVES FUEL OIL GASOLINE OR LUBRICATING OIL... | HALB | Semifinished product | KG | 1.077 | 1010B06020 | Fin.Petr Prod ex Lu | 10.0 | CP&S ex Lubes | 1010.0 | Chemicals | 0000001010B0 | Additives | 00001010B060 | Lubes Additives | 001010B06020 | NaN | NaN | 720 | NaN | RBLK | L15 | VOLUME REPORTING | VR9999 | LUBES | VR3999 | L06 LUBE-ADDITIVES | VR3499 | LUBE ADDITIVES | VR3401 | KG |
| 2 | NaN | NaN | NaN | NaN | NaN | 260.0 | Finished Lubes | Products | Lubes | NaN | STRIPES_AM | 100035 | Base | Refy Oth External Input | 20 | Non-Proc Refy Inputs | 18 | Additives | 38 | Fuels Additives | 381 | 90039042.0 | 970122 | LOBASE C4506 | XOM | ExxonMobil | BULK | BULK | NON | None | STOCK | STOCK | OTHER | OTHER | ADD | Additive | 1010B06020 | MIN | Mineral | 100035 | NaN | STOCK 2216.0BULKLOBASE C4506. | 100035 STOCK 2216.0BULKLOBASE C4506. | 09:24.0 | 4.0 | 1 | LSB-ADD | Lube Additive Bulk | 100035 | 100035 | 1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2911415.0 | PETROLEUM LUBRICATING OIL | HALB | Semifinished product | KG | 1.058 | 1010B06020 | Fin.Petr Prod ex Lu | 10.0 | CP&S ex Lubes | 1010.0 | Chemicals | 0000001010B0 | Additives | 00001010B060 | Lubes Additives | 001010B06020 | NaN | NaN | 1,080 | NaN | RBLK | L15 | VOLUME REPORTING | VR9999 | LUBES | VR3999 | L06 LUBE-ADDITIVES | VR3499 | LUBE ADDITIVES | VR3401 | KG |
| 3 | NaN | NaN | NaN | NaN | NaN | 260.0 | Finished Lubes | Products | Lubes | NaN | STRIPES_AM | 100038 | Base | Refy Oth External Input | 20 | Non-Proc Refy Inputs | 18 | Additives | 38 | Fuels Additives | 381 | NaN | 971391 | WATER | XOM | ExxonMobil | BULK | BULK | NON | None | STOCK | STOCK | OTHER | OTHER | ADD | Additive | 1010B06020 | MIN | Mineral | 100038 | NaN | STOCK 0999.0BULKWATER. | 100038 STOCK 0999.0BULKWATER. | 09:24.0 | 4.0 | 1 | LSB-ADD | Lube Additive Bulk | 100038 | 100038 | 1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | HALB | Semifinished product | KG | 1.003 | 1010B06020 | Fin.Petr Prod ex Lu | 10.0 | CP&S ex Lubes | 1010.0 | Chemicals | 0000001010B0 | Additives | 00001010B060 | Lubes Additives | 001010B06020 | NaN | NaN | 3,520 | NaN | RBLK | L15 | VOLUME REPORTING | VR9999 | LUBES | VR3999 | L08 LUBE-NO VALUE LUBES PRODUCTS | VR3699 | WATER-NO VALUE | VR3601 | KG |
| 4 | NaN | NaN | NaN | NaN | NaN | 40.0 | Motor Gasoline | Products | Fuels | NaN | STRIPES_AM | NaN | Base | Fuels Finished Petroleum Product | 30 | Clean Products | 20 | Motor Gasoline | 50 | Intermediate | 502 | NaN | NaN | NaN | NaN | NaN | BULK | BULK | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 100046 | NaN | PRICE_REF: 89 CONV 3.5%O2 BRANDED. | 100046 PRICE_REF: 89 CONV 3.5%O2 BRANDED. | 09:24.0 | 2.0 | 1,000 | ZZ-PRICE | PH3=101010 PRDNN=PRICE REF: | 100046 | 100046 | 1,000 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | HALB | Semifinished product | M15 | 1,000 | 10101035 | Fin.Petr Prod ex Lu | 10.0 | CP&S ex Lubes | 1010.0 | Motor Gasoline | 101010 | Intermediate UL w Eth | 10101035 | NaN | NaN | NaN | NaN | 0 | NaN | RBLK | L15 | VOLUME REPORTING | VR9999 | MOGAS | VR5999 | P04 SPECIAL | VR5199 | SPECIAL RFG W/MTBE | VR5105 | KG |
| 5 | NaN | NaN | NaN | NaN | NaN | 40.0 | Motor Gasoline | Products | Fuels | NaN | STRIPES_AM | NaN | Base | Fuels Finished Petroleum Product | 30 | Clean Products | 20 | Motor Gasoline | 50 | Mogas Discounts Rebates Cards Oth | 506 | NaN | NaN | NaN | NaN | NaN | BULK | BULK | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 100050 | NaN | PRICE_REF: 92 CONV 3.5%O2 BRANDED. | 100050 PRICE_REF: 92 CONV 3.5%O2 BRANDED. | 09:24.0 | 2.0 | 1,000 | ZZ-PRICE | PH3=101010 PRDNN=PRICE REF: | 100050 | 100050 | 1,000 | PREMCBOBSUM | Premium CBOB SUMMER GRADE | Mogas | PREMCBOB | Premium CBOB | Mogas | NaN | NaN | NaN | HALB | Semifinished product | M15 | 1,000 | 10101015 | Fin.Petr Prod ex Lu | 10.0 | CP&S ex Lubes | 1010.0 | Motor Gasoline | 101010 | Premium UL with Eth | 10101015 | NaN | NaN | NaN | NaN | 0 | NaN | RBLK | L15 | VOLUME REPORTING | VR9999 | MOGAS | VR5999 | P03 SUPER | VR5099 | SUPER CONVENTIONAL - SUMMER BLEND | VR5010 | KG |
| 6 | NaN | NaN | NaN | NaN | NaN | 85.0 | Distillate Fuels | Products | Fuels | NaN | STRIPES_AM | NaN | Base | Fuels Finished Petroleum Product | 30 | Clean Products | 20 | Land Diesel | 51 | Regular ADO | 512 | NaN | NaN | NaN | NaN | NaN | BULK | BULK | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 100053 | NaN | PRICE_REF: NO.2 FUEL OIL DYED#180018. | 100053 PRICE_REF: NO.2 FUEL OIL DYED#180018. | 09:24.0 | 2.0 | 1,000 | ZZ-PRICE | PH3=101010 PRDNN=PRICE REF: | 100053 | 100053 | 1,000 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | HALB | Semifinished product | M15 | 1,000 | 10102015 | Fin.Petr Prod ex Lu | 10.0 | CP&S ex Lubes | 1010.0 | Diesel | 101020 | Regular ADO | 10102015 | NaN | NaN | NaN | NaN | 0 | NaN | RBLK | L15 | VOLUME REPORTING | VR9999 | DISTILLATES | VR6999 | P09 FINISHED DISTILLATES | VR6099 | S>500 NRLM NO.2 DSL | VR6007 | KG |
| 7 | NaN | NaN | NaN | NaN | NaN | 40.0 | Motor Gasoline | Products | Fuels | NaN | STRIPES_AM | NaN | Base | Fuels Finished Petroleum Product | 30 | Clean Products | 20 | Motor Gasoline | 50 | Intermediate | 502 | NaN | NaN | NaN | NaN | NaN | BULK | BULK | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 100054 | NaN | PRICE_REF: 89 OCT CONV BRANDED. | 100054 PRICE_REF: 89 OCT CONV BRANDED. | 09:24.0 | 2.0 | 1,000 | ZZ-PRICE | PH3=101010 PRDNN=PRICE REF: | 100054 | 100054 | 1,000 | MIDCBOB | Mid-Grade CBOB | Mogas | # | # | # | NaN | NaN | NaN | HALB | Semifinished product | M15 | 1,000 | 10101030 | Fin.Petr Prod ex Lu | 10.0 | CP&S ex Lubes | 1010.0 | Motor Gasoline | 101010 | Intermediate UL | 10101030 | NaN | NaN | NaN | NaN | 0 | NaN | RBLK | L15 | VOLUME REPORTING | VR9999 | MOGAS | VR5999 | P04 SPECIAL | VR5199 | SPECIAL CONVENTIONAL | VR5101 | KG |
| 8 | NaN | NaN | NaN | NaN | NaN | 40.0 | Motor Gasoline | Products | Fuels | NaN | STRIPES_AM | NaN | Base | Fuels Finished Petroleum Product | 30 | Clean Products | 20 | Motor Gasoline | 50 | Regular | 503 | NaN | NaN | NaN | NaN | NaN | BULK | BULK | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 100056 | NaN | PRICE_REF: 87 CONV 3.5%O2 BRANDED. | 100056 PRICE_REF: 87 CONV 3.5%O2 BRANDED. | 09:24.0 | 2.0 | 1,000 | ZZ-PRICE | PH3=101010 PRDNN=PRICE REF: | 100056 | 100056 | 1,000 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | HALB | Semifinished product | M15 | 1,000 | 10101055 | Fin.Petr Prod ex Lu | 10.0 | CP&S ex Lubes | 1010.0 | Motor Gasoline | 101010 | Regular UL w Eth | 10101055 | NaN | NaN | NaN | NaN | 0 | NaN | RBLK | L15 | VOLUME REPORTING | VR9999 | MOGAS | VR5999 | P05 UNLEADED | VR5299 | UNLEADED RFG W/MTBE | VR5205 | KG |
| 9 | NaN | NaN | NaN | NaN | NaN | 85.0 | Distillate Fuels | Products | Fuels | NaN | STRIPES_AM | NaN | Base | Fuels Finished Petroleum Product | 30 | Clean Products | 20 | Land Diesel | 51 | Regular ADO | 512 | NaN | NaN | NaN | NaN | NaN | BULK | BULK | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 100063 | NaN | PRICE_REF: S500 LM NO.2 DSL ADD DYED. | 100063 PRICE_REF: S500 LM NO.2 DSL ADD DYED. | 09:24.0 | 2.0 | 1,000 | ZZ-PRICE | PH3=101010 PRDNN=PRICE REF: | 100063 | 100063 | 1,000 | S500DSL | S500 Diesel | Distillate | S500DSL | S500 Diesel | Distillate | NaN | NaN | NaN | HALB | Semifinished product | M15 | 1,000 | 10102015 | Fin.Petr Prod ex Lu | 10.0 | CP&S ex Lubes | 1010.0 | Diesel | 101020 | Regular ADO | 10102015 | NaN | NaN | NaN | NaN | 0 | NaN | RBLK | L15 | VOLUME REPORTING | VR9999 | DISTILLATES | VR6999 | P09 FINISHED DISTILLATES | VR6099 | S500 NRLM NO.2 DSL | VR6017 | KG |
Last rows
| ADDITIVES_BRANDED_DIESEL_IND | ADDITIVES_BRANDED_GASOLINE_IND | ADDITIVES_DYE_IND | ADDITIVES_LUBRICITY_IND | ADDITIVES_UNBRANDED_GASOLINE_IND | CF3030_LINE_CODE | CF3030_LINE_DESC | CF3030_LINE_LVL1_DESC | CF3030_LINE_LVL2_DESC | CONTAINER_REQUIREMENTS | DH_SRC | EMAPSS_MATERIAL | FUELS_BASE_IND | GLOB_PROD_LVL1 | GLOB_PROD_LVL1_NO | GLOB_PROD_LVL2 | GLOB_PROD_LVL2_NO | GLOB_PROD_LVL3 | GLOB_PROD_LVL3_NO | GLOB_PROD_LVL4 | GLOB_PROD_LVL4_NO | GOM_MATERIAL | GPAQS_CMCS_CODE | GPAQS_MATERIAL_NAME | LS_GLOBAL_BRAND | LS_GLOBAL_BRAND_DESC | LS_GLOBAL_BULK_PACK_ID | LS_GLOBAL_PACKAGE_GROUP | LS_GLOBAL_PREMIUM_IND | LS_GLOBAL_PREMIUM_IND_DESC | LS_GLOBAL_PROD_FAMILY | LS_GLOBAL_PROD_FAMILY_DESC | LS_GLOBAL_PRODUCT_GROUP | LS_GLOBAL_PRODUCT_GROUP_DESC | LS_GLOBAL_PRODUCT_LINE | LS_GLOBAL_PRODUCT_LINE_DESC | LS_GLOBAL_PRODUCT_NUMBER | LS_GLOBAL_SYNTHETIC_IND | LS_GLOBAL_SYNTHETIC_IND_DESC | MATERIAL | MATERIAL_DEL_IND | MATERIAL_DESC | MATERIAL_DESC_CONCAT | MATERIAL_DH_UPDATE_TIMESTAMP | MATERIAL_DIVISION | MATERIAL_GROSS_WEIGHT | MATERIAL_GROUP | MATERIAL_GROUP_DESC | MATERIAL_KEY | MATERIAL_MD | MATERIAL_NET_WEIGHT | MATERIAL_PROD_FAMILY_BLENDED | MATERIAL_PROD_FAMILY_BLENDED_DESC | MATERIAL_PROD_FAMILY_BLENDED_GROUP | MATERIAL_PROD_FAMILY_UNBLENDED | MATERIAL_PROD_FAMILY_UNBLENDED_DESC | MATERIAL_PROD_FAMILY_UNBLENDED_GROUP | MATERIAL_SOURCE_SYSTEM | MATERIAL_STCC | MATERIAL_STCC_DESC | MATERIAL_TYPE | MATERIAL_TYPE_DESC | MATERIAL_UOM | MATERIAL_VOL | PROD_HIER | PROD_LVL1 | PROD_LVL1_NO | PROD_LVL2 | PROD_LVL2_NO | PROD_LVL3 | PROD_LVL3_NO | PROD_LVL4 | PROD_LVL4_NO | PROD_LVL5 | PROD_LVL5_NO | PROD_LVL6 | PROD_LVL6_NO | PROMIS_SHELF_LIFE | SHIPNET_COMMODITY | TRANSPORT_GROUP | VOL_UOM_CODE | VR_CLASS_LVL1 | VR_CLASS_LVL1_NO | VR_CLASS_LVL2 | VR_CLASS_LVL2_NO | VR_CLASS_LVL3 | VR_CLASS_LVL3_NO | VR_CLASS_LVL4 | VR_CLASS_LVL4_NO | WEIGHT_UOM_CODE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2958 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | DSDW_W7 | NaN | Base | Fuels Finished Petroleum Product | 30 | Clean Products | 20 | Land Diesel | 51 | Other Distillate | 514 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | FM_OTHDIST | NaN | NaN | FM_OTHDIST | 09:24.0 | NaN | 0 | NaN | NaN | FM_OTHDIST | FM_OTHDIST | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2959 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | DSDW_W7 | NaN | Base | Fuels Finished Petroleum Product | 30 | Clean Products | 20 | Other Petroleum | 56 | Other Petroleum Fuels | 565 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | FM_OTHPP | NaN | NaN | FM_OTHPP | 09:24.0 | NaN | 0 | NaN | NaN | FM_OTHPP | FM_OTHPP | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2960 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | DSDW_W7 | NaN | Base | Fuels Finished Petroleum Product | 30 | Clean Products | 20 | Land Diesel | 51 | Other Engine Diesel | 513 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | FM_TDLHD | NaN | NaN | FM_TDLHD | 09:24.0 | NaN | 0 | NaN | NaN | FM_TDLHD | FM_TDLHD | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2961 | NaN | NaN | NaN | NaN | NaN | 999.0 | Unassigned Classes | Unassigned Classes | Unassigned Classes | NaN | DSDW_W7 | NaN | Base | Fuels Finished Petroleum Product | 30 | Clean Products | 20 | Motor Gasoline | 50 | Regular | 503 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | RS_LOGIST_PR | NaN | NaN | RS_LOGIST_PR | 09:24.0 | 2.0 | 1,000 | MOGAS | PH3=101010 | RS_LOGIST_PR | RS_LOGIST_PR | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | HALB | Semifinished product | M15 | 0 | 10101050 | Fin.Petr Prod ex Lu | 10.0 | CP&S ex Lubes | 1010.0 | Motor Gasoline | 101010 | Regular UL | 10101050 | NaN | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | KG |
| 2962 | NaN | NaN | NaN | NaN | NaN | 999.0 | Unassigned Classes | Unassigned Classes | Unassigned Classes | NaN | DSDW_W7 | NaN | Base | Fuels Finished Petroleum Product | 30 | Clean Products | 20 | Motor Gasoline | 50 | Regular | 503 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | RS_RGSPEARN_PR | NaN | NaN | RS_RGSPEARN_PR | 09:24.0 | 2.0 | 1,000 | MOGAS | PH3=101010 | RS_RGSPEARN_PR | RS_RGSPEARN_PR | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | HALB | Semifinished product | M15 | 0 | 10101050 | Fin.Petr Prod ex Lu | 10.0 | CP&S ex Lubes | 1010.0 | Motor Gasoline | 101010 | Regular UL | 10101050 | NaN | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | KG |
| 2963 | NaN | NaN | NaN | NaN | NaN | 999.0 | Unassigned Classes | Unassigned Classes | Unassigned Classes | NaN | DSDW_W7 | NaN | Base | Fuels Finished Petroleum Product | 30 | Clean Products | 20 | Motor Gasoline | 50 | Regular | 503 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | RS_UNDEF_PROD1 | NaN | NaN | RS_UNDEF_PROD1 | 09:24.0 | 2.0 | 1,000 | MOGAS | PH3=101010 | RS_UNDEF_PROD1 | RS_UNDEF_PROD1 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | HALB | Semifinished product | M15 | 0 | 10101050 | Fin.Petr Prod ex Lu | 10.0 | CP&S ex Lubes | 1010.0 | Motor Gasoline | 101010 | Regular UL | 10101050 | NaN | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | KG |
| 2964 | NaN | NaN | NaN | NaN | NaN | 999.0 | Unassigned Classes | Unassigned Classes | Unassigned Classes | NaN | DSDW_W7 | NaN | Base | Fuels Finished Petroleum Product | 30 | Clean Products | 20 | Motor Gasoline | 50 | Regular | 503 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | RS_UNDEF_PROD2 | NaN | NaN | RS_UNDEF_PROD2 | 09:24.0 | 2.0 | 1,000 | MOGAS | PH3=101010 | RS_UNDEF_PROD2 | RS_UNDEF_PROD2 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | HALB | Semifinished product | M15 | 0 | 10101050 | Fin.Petr Prod ex Lu | 10.0 | CP&S ex Lubes | 1010.0 | Motor Gasoline | 101010 | Regular UL | 10101050 | NaN | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | KG |
| 2965 | NaN | NaN | NaN | NaN | NaN | 999.0 | Unassigned Classes | Unassigned Classes | Unassigned Classes | NaN | DSDW_W7 | NaN | Base | Fuels Finished Petroleum Product | 30 | Clean Products | 20 | Motor Gasoline | 50 | Regular | 503 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | RS_UNDEF_PROD3 | NaN | NaN | RS_UNDEF_PROD3 | 09:24.0 | 2.0 | 1,000 | MOGAS | PH3=101010 | RS_UNDEF_PROD3 | RS_UNDEF_PROD3 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | HALB | Semifinished product | M15 | 0 | 10101050 | Fin.Petr Prod ex Lu | 10.0 | CP&S ex Lubes | 1010.0 | Motor Gasoline | 101010 | Regular UL | 10101050 | NaN | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | KG |
| 2966 | NaN | NaN | NaN | NaN | NaN | 999.0 | Unassigned Classes | Unassigned Classes | Unassigned Classes | NaN | DSDW_W7 | NaN | Base | Fuels Finished Petroleum Product | 30 | Clean Products | 20 | Motor Gasoline | 50 | Regular | 503 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | RS_UNDEF_PROD4 | NaN | NaN | RS_UNDEF_PROD4 | 09:24.0 | 2.0 | 1,000 | MOGAS | PH3=101010 | RS_UNDEF_PROD4 | RS_UNDEF_PROD4 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | HALB | Semifinished product | M15 | 0 | 10101050 | Fin.Petr Prod ex Lu | 10.0 | CP&S ex Lubes | 1010.0 | Motor Gasoline | 101010 | Regular UL | 10101050 | NaN | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | KG |
| 2967 | NaN | NaN | NaN | NaN | NaN | 999.0 | Unassigned Classes | Unassigned Classes | Unassigned Classes | NaN | DSDW_W7 | NaN | Base | Fuels Finished Petroleum Product | 30 | Clean Products | 20 | Motor Gasoline | 50 | Regular | 503 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | RS_UNDEF_PROD5 | NaN | NaN | RS_UNDEF_PROD5 | 09:24.0 | 2.0 | 1,000 | MOGAS | PH3=101010 | RS_UNDEF_PROD5 | RS_UNDEF_PROD5 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | HALB | Semifinished product | M15 | 0 | 10101050 | Fin.Petr Prod ex Lu | 10.0 | CP&S ex Lubes | 1010.0 | Motor Gasoline | 101010 | Regular UL | 10101050 | NaN | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | KG |